[dbo].[BAEImisNameAddressGet]

SQLServer > iMIS1521GA > Stored Procedures > dbo.BAEImisNameAddressGet

Properties
Parameters
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On

Parameters

Name	Data Type	Max Length (Bytes)
@Id	varchar(10)	10
@addressnum	int	4

SQL Script

create procedure [dbo].[BAEImisNameAddressGet] @Id varchar(10),
@addressnum int as
SELECT * FROM Name_Address WHERE ADDRESS_NUM = @addressnum AND ID = @Id

GO

Uses

[dbo].[Name_Address]
dbo